Tabela AdmissionMode

Definicja tabeli AdmissionMode

Name

AdmissionMode

Code

AdmissionMode

Comment

PL: Tabela dla trybów przyjecia
EN: Table for admission modes
DE: Die Tabelle fur die Art der Aufnahme


Lista kolumn tabeli AdmissionMode

Name

Code

AdmissionModeID

AdmissionModeID

InternalValueID

InternalValueID

EpisodeTypeID

EpisodeTypeID

StartDT

StartDT

StopDT

StopDT

Active

Active

StatCode

StatCode


Kolumna AdmissionModeID tabeli AdmissionMode

Definicja kolumny AdmissionModeID tabeli AdmissionMode

Name

AdmissionModeID

Code

AdmissionModeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InternalValueID tabeli AdmissionMode

Definicja kolumny InternalValueID tabeli AdmissionMode

Name

InternalValueID

Code

InternalValueID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EpisodeTypeID tabeli AdmissionMode

Definicja kolumny EpisodeTypeID tabeli AdmissionMode

Name

EpisodeTypeID

Code

EpisodeTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli AdmissionMode

Definicja kolumny StartDT tabeli AdmissionMode

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli AdmissionMode

Definicja kolumny StopDT tabeli AdmissionMode

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Active tabeli AdmissionMode

Definicja kolumny Active tabeli AdmissionMode

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna StatCode tabeli AdmissionMode

Definicja kolumny StatCode tabeli AdmissionMode

Name

StatCode

Code

StatCode

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Kod resortowy


Lista kluczy tabeli AdmissionMode

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli AdmissionMode

Definicja klucza Identifier_1 tabeli AdmissionMode

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment